Overview

Dataset statistics

Number of variables17
Number of observations215094
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory177.6 MiB
Average record size in memory865.7 B

Variable types

CAT9
NUM8

Reproduction

Analysis started2020-03-05 10:30:49.192956
Analysis finished2020-03-05 10:41:24.143972
Versionpandas-profiling v2.5.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
회원번호 has a high cardinality: 215094 distinct values High cardinality
회원이름 has a high cardinality: 150751 distinct values High cardinality
가입일자 has a high cardinality: 3593 distinct values High cardinality
최종불입일자 has a high cardinality: 3252 distinct values High cardinality
담당자 has a high cardinality: 2157 distinct values High cardinality
부서 has a high cardinality: 575 distinct values High cardinality
가입일자 only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
최종불입일자 only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
해약금액 has 176137 (81.9%) zeros Zeros
연체횟수 has 118228 (55.0%) zeros Zeros

Variables

df_index
Real number (ℝ≥0)

UNIQUE
Distinct count215094
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean120606.92464224943
Minimum0
Maximum234612
Zeros1
Zeros (%)< 0.1%
Memory size1.6 MiB

Quantile statistics

Minimum0
5-th percentile12196.65
Q164479.25
median121871.5
Q3178243.75
95-th percentile222708.35
Maximum234612
Range234612
Interquartile range (IQR)113764.5

Descriptive statistics

Standard deviation66721.49409
Coefficient of variation (CV)0.553214455
Kurtosis-1.159724153
Mean120606.9246
Median Absolute Deviation (MAD)57552.93947
Skewness-0.06307497504
Sum2.594182585e+10
Variance4451757774
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 11343.5 19639.5 36392.5 53461.5 ... 226652.5 228076.5 228248.5 228347.5 234612. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2047 1 < 0.1%
 
213309 1 < 0.1%
 
4439 1 < 0.1%
 
6486 1 < 0.1%
 
341 1 < 0.1%
 
2388 1 < 0.1%
 
14674 1 < 0.1%
 
8529 1 < 0.1%
 
10576 1 < 0.1%
 
53583 1 < 0.1%
 
Other values (215084) 215084 > 99.9%
 
ValueCountFrequency (%) 
0 1 < 0.1%
 
1 1 < 0.1%
 
2 1 < 0.1%
 
3 1 < 0.1%
 
4 1 < 0.1%
 
ValueCountFrequency (%) 
234612 1 < 0.1%
 
234611 1 < 0.1%
 
234610 1 < 0.1%
 
234609 1 < 0.1%
 
234607 1 < 0.1%
 

회원번호
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE
Distinct count215094
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.6 MiB
3011A03755
 
1
3011A04136
 
1
210A004749
 
1
218A030696
 
1
217B014992
 
1
Other values (215089)
215089
ValueCountFrequency (%) 
3011A03755 1 < 0.1%
 
3011A04136 1 < 0.1%
 
210A004749 1 < 0.1%
 
218A030696 1 < 0.1%
 
217B014992 1 < 0.1%
 
218A067289 1 < 0.1%
 
1022A05193 1 < 0.1%
 
214A005552 1 < 0.1%
 
214A003441 1 < 0.1%
 
218A032505 1 < 0.1%
 
Other values (215084) 215084 > 99.9%
 

Length

Max length11
Mean length10.00073456
Min length10
ValueCountFrequency (%) 
Uppercase_Letter 16 57.1%
 
Decimal_Number 10 35.7%
 
Connector_Punctuation 1 3.6%
 
Dash_Punctuation 1 3.6%
 
ValueCountFrequency (%) 
Latin 16 57.1%
 
Common 12 42.9%
 
ValueCountFrequency (%) 
ASCII 28 100.0%
 

회원이름
Categorical

HIGH CARDINALITY
UNIFORM
Distinct count150751
Unique (%)70.1%
Missing0
Missing (%)0.0%
Memory size1.6 MiB
주식회사에프피에이110111
 
70
임덕길470529
 
24
대성건설(주)124-81
 
20
백승식720219
 
12
강성복551227
 
12
Other values (150746)
214956
ValueCountFrequency (%) 
주식회사에프피에이110111 70 < 0.1%
 
임덕길470529 24 < 0.1%
 
대성건설(주)124-81 20 < 0.1%
 
백승식720219 12 < 0.1%
 
강성복551227 12 < 0.1%
 
(주)지케이씨교역540605 10 < 0.1%
 
김숙경550210 9 < 0.1%
 
안규덕631212 8 < 0.1%
 
조상영551213 8 < 0.1%
 
김현영731018 8 < 0.1%
 
Other values (150741) 214913 99.9%
 

Length

Max length25
Mean length9.006541326
Min length8
ValueCountFrequency (%) 
Other_Letter 502 90.6%
 
Uppercase_Letter 26 4.7%
 
Decimal_Number 10 1.8%
 
Lowercase_Letter 9 1.6%
 
Other_Punctuation 3 0.5%
 
Dash_Punctuation 1 0.2%
 
Open_Punctuation 1 0.2%
 
Space_Separator 1 0.2%
 
Close_Punctuation 1 0.2%
 
ValueCountFrequency (%) 
Hangul 502 90.6%
 
Latin 35 6.3%
 
Common 17 3.1%
 
ValueCountFrequency (%) 
Hangul 502 90.6%
 
ASCII 52 9.4%
 

주소
Categorical

Distinct count46
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.6 MiB
경기
59425
서울
54498
인천
16745
경상
 
11440
광주
 
9080
Other values (41)
63906
ValueCountFrequency (%) 
경기 59425 27.6%
 
서울 54498 25.3%
 
인천 16745 7.8%
 
경상 11440 5.3%
 
광주 9080 4.2%
 
부산 8535 4.0%
 
전라 8133 3.8%
 
강원 7861 3.7%
 
충청 7778 3.6%
 
대전 6562 3.1%
 
Other values (36) 25037 11.6%
 

Length

Max length2
Mean length1.999958158
Min length1
ValueCountFrequency (%) 
Other_Letter 46 93.9%
 
Other_Punctuation 1 2.0%
 
Space_Separator 1 2.0%
 
Decimal_Number 1 2.0%
 
ValueCountFrequency (%) 
Hangul 46 93.9%
 
Common 3 6.1%
 
ValueCountFrequency (%) 
Hangul 46 93.9%
 
ASCII 3 6.1%
 

상태
Categorical

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.6 MiB
가입
106467
해약
84623
만기
 
10804
행사
 
9472
만기_해약
 
3665
ValueCountFrequency (%) 
가입 106467 49.5%
 
해약 84623 39.3%
 
만기 10804 5.0%
 
행사 9472 4.4%
 
만기_해약 3665 1.7%
 
해지 63 < 0.1%
 

Length

Max length5
Mean length2.051117186
Min length2
ValueCountFrequency (%) 
Other_Letter 9 90.0%
 
Connector_Punctuation 1 10.0%
 
ValueCountFrequency (%) 
Hangul 9 90.0%
 
Common 1 10.0%
 
ValueCountFrequency (%) 
Hangul 9 90.0%
 
ASCII 1 10.0%
 

가입일자
Categorical

HIGH CARDINALITY
TYPE DATE
Distinct count3593
Unique (%)1.7%
Missing0
Missing (%)0.0%
Memory size1.6 MiB
2018-07-25
 
698
2018-11-29
 
662
2014-03-03
 
642
2018-11-28
 
609
2018-11-19
 
601
Other values (3588)
211882
ValueCountFrequency (%) 
2018-07-25 698 0.3%
 
2018-11-29 662 0.3%
 
2014-03-03 642 0.3%
 
2018-11-28 609 0.3%
 
2018-11-19 601 0.3%
 
2018-12-17 600 0.3%
 
2018-12-24 581 0.3%
 
2018-11-26 579 0.3%
 
2014-07-28 578 0.3%
 
2018-11-22 574 0.3%
 
Other values (3583) 208970 97.2%
 

Length

Max length10
Mean length10
Min length10
ValueCountFrequency (%) 
Decimal_Number 10 90.9%
 
Dash_Punctuation 1 9.1%
 
ValueCountFrequency (%) 
Common 11 100.0%
 
ValueCountFrequency (%) 
ASCII 11 100.0%
 

최종불입일자
Categorical

HIGH CARDINALITY
TYPE DATE
Distinct count3252
Unique (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.6 MiB
2018-12-26
36888
2018-12-17
 
13932
2018-12-10
 
13718
2018-12-20
 
13366
2018-12-05
 
11042
Other values (3247)
126148
ValueCountFrequency (%) 
2018-12-26 36888 17.1%
 
2018-12-17 13932 6.5%
 
2018-12-10 13718 6.4%
 
2018-12-20 13366 6.2%
 
2018-12-05 11042 5.1%
 
2018-12-31 2759 1.3%
 
2018-11-26 1239 0.6%
 
2018-12-12 1237 0.6%
 
2018-12-28 881 0.4%
 
2018-12-14 793 0.4%
 
Other values (3242) 119239 55.4%
 

Length

Max length10
Mean length10
Min length10
ValueCountFrequency (%) 
Decimal_Number 10 90.9%
 
Dash_Punctuation 1 9.1%
 
ValueCountFrequency (%) 
Common 11 100.0%
 
ValueCountFrequency (%) 
ASCII 11 100.0%
 

총납입회차
Real number (ℝ≥0)

Distinct count26
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean234.8908849154323
Minimum1
Maximum390
Zeros0
Zeros (%)0.0%
Memory size1.6 MiB

Quantile statistics

Minimum1
5-th percentile100
Q1120
median250
Q3360
95-th percentile390
Maximum390
Range389
Interquartile range (IQR)240

Descriptive statistics

Standard deviation117.6439237
Coefficient of variation (CV)0.5008449934
Kurtosis-1.624186994
Mean234.8908849
Median Absolute Deviation (MAD)107.2700267
Skewness0.09744827917
Sum50523620
Variance13840.09278
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 1. 20. 39.5 55. 62. ... 262. 282. 330. 375. 390. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
100 48068 22.3%
 
390 41279 19.2%
 
360 33260 15.5%
 
260 28902 13.4%
 
130 21202 9.9%
 
250 15651 7.3%
 
140 15100 7.0%
 
120 4969 2.3%
 
60 3564 1.7%
 
160 1273 0.6%
 
Other values (16) 1826 0.8%
 
ValueCountFrequency (%) 
1 207 0.1%
 
39 1 < 0.1%
 
40 6 < 0.1%
 
44 1 < 0.1%
 
48 7 < 0.1%
 
ValueCountFrequency (%) 
390 41279 19.2%
 
360 33260 15.5%
 
300 48 < 0.1%
 
264 217 0.1%
 
260 28902 13.4%
 

최종불입회차
Real number (ℝ≥0)

Distinct count139
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean31.09372181464848
Minimum1
Maximum488
Zeros0
Zeros (%)0.0%
Memory size1.6 MiB

Quantile statistics

Minimum1
5-th percentile1
Q13
median13
Q352
95-th percentile100
Maximum488
Range487
Interquartile range (IQR)49

Descriptive statistics

Standard deviation39.82158922
Coefficient of variation (CV)1.280695487
Kurtosis17.96679186
Mean31.09372181
Median Absolute Deviation (MAD)29.88623994
Skewness2.926227284
Sum6688073
Variance1585.758968
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 280. 330. 375. 439. 488. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 34541 16.1%
 
100 19128 8.9%
 
2 15158 7.0%
 
3 10277 4.8%
 
6 8230 3.8%
 
4 7548 3.5%
 
5 6984 3.2%
 
7 5307 2.5%
 
8 4968 2.3%
 
12 4361 2.0%
 
Other values (129) 98592 45.8%
 
ValueCountFrequency (%) 
1 34541 16.1%
 
2 15158 7.0%
 
3 10277 4.8%
 
4 7548 3.5%
 
5 6984 3.2%
 
ValueCountFrequency (%) 
488 1 < 0.1%
 
390 257 0.1%
 
360 499 0.2%
 
300 2 < 0.1%
 
260 116 0.1%
 

상품금액
Real number (ℝ≥0)

Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.6972672412991527
Minimum0
Maximum8
Zeros43
Zeros (%)< 0.1%
Memory size1.6 MiB

Quantile statistics

Minimum0
5-th percentile1
Q12
median3
Q33
95-th percentile4
Maximum8
Range8
Interquartile range (IQR)1

Descriptive statistics

Standard deviation0.6990751499
Coefficient of variation (CV)0.2591790458
Kurtosis0.5855036068
Mean2.697267241
Median Absolute Deviation (MAD)0.5646757043
Skewness-0.5837855077
Sum580166
Variance0.4887060652
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0. 1.5 2.5 3.5 4.5 6.5 8. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
3 131303 61.0%
 
2 54414 25.3%
 
4 15839 7.4%
 
1 13358 6.2%
 
5 127 0.1%
 
0 43 < 0.1%
 
8 10 < 0.1%
 
ValueCountFrequency (%) 
0 43 < 0.1%
 
1 13358 6.2%
 
2 54414 25.3%
 
3 131303 61.0%
 
4 15839 7.4%
 
ValueCountFrequency (%) 
8 10 < 0.1%
 
5 127 0.1%
 
4 15839 7.4%
 
3 131303 61.0%
 
2 54414 25.3%
 

총불입액
Real number (ℝ≥0)

Distinct count935
Unique (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean593565.8413298372
Minimum750
Maximum4880000
Zeros0
Zeros (%)0.0%
Memory size1.6 MiB

Quantile statistics

Minimum750
5-th percentile10000
Q145000
median240000
Q3600000
95-th percentile2400000
Maximum4880000
Range4879250
Interquartile range (IQR)555000

Descriptive statistics

Standard deviation809766.6329
Coefficient of variation (CV)1.364240623
Kurtosis1.691116703
Mean593565.8413
Median Absolute Deviation (MAD)607784.8182
Skewness1.649109372
Sum1.276724511e+11
Variance6.557219998e+11
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[7.500e+02 8.750e+02 1.250e+03 5.625e+03 9.125e+03 ... 3.306e+06 3.582e+06 3.750e+06 3.990e+06 4.880e+06], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
10000 13853 6.4%
 
2400000 13538 6.3%
 
30000 8544 4.0%
 
15000 7931 3.7%
 
1980000 6289 2.9%
 
20000 5958 2.8%
 
60000 5126 2.4%
 
90000 5048 2.3%
 
18000 4548 2.1%
 
180000 3714 1.7%
 
Other values (925) 140545 65.3%
 
ValueCountFrequency (%) 
750 137 0.1%
 
1000 49 < 0.1%
 
1500 6 < 0.1%
 
2000 7 < 0.1%
 
2250 6 < 0.1%
 
ValueCountFrequency (%) 
4880000 1 < 0.1%
 
4848000 1 < 0.1%
 
4800000 3 < 0.1%
 
4640000 1 < 0.1%
 
4500000 13 < 0.1%
 

해약금액
Real number (ℝ≥0)

ZEROS
Distinct count1824
Unique (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean98528.11243921262
Minimum0
Maximum3876000
Zeros176137
Zeros (%)81.9%
Memory size1.6 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile858350
Maximum3876000
Range3876000
Interquartile range (IQR)0

Descriptive statistics

Standard deviation353750.1703
Coefficient of variation (CV)3.590347583
Kurtosis16.95820195
Mean98528.11244
Median Absolute Deviation (MAD)174273.7362
Skewness4.112052435
Sum2.119280582e+10
Variance1.25139183e+11
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.0000000e+00 3.1500000e+02 6.9000000e+02 8.0000000e+02 1.1350000e+03 ... 2.6287250e+06 2.6507100e+06 2.6507225e+06 2.7045000e+06 3.8760000e+06], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 176137 81.9%
 
10000 7801 3.6%
 
15000 2470 1.1%
 
1944000 1955 0.9%
 
18000 1538 0.7%
 
20000 1431 0.7%
 
1603000 1119 0.5%
 
24000 1099 0.5%
 
28000 481 0.2%
 
30000 372 0.2%
 
Other values (1814) 20691 9.6%
 
ValueCountFrequency (%) 
0 176137 81.9%
 
630 17 < 0.1%
 
750 120 0.1%
 
850 16 < 0.1%
 
1000 33 < 0.1%
 
ValueCountFrequency (%) 
3876000 2 < 0.1%
 
3664000 1 < 0.1%
 
3600000 1 < 0.1%
 
3163310 1 < 0.1%
 
3149250 1 < 0.1%
 

담당자
Categorical

HIGH CARDINALITY
Distinct count2157
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size1.6 MiB
더피플라이프
72013
금강종합상조(주)
28707
강대석
 
6336
김영권
 
4857
이덕술
 
4749
Other values (2152)
98432
ValueCountFrequency (%) 
더피플라이프 72013 33.5%
 
금강종합상조(주) 28707 13.3%
 
강대석 6336 2.9%
 
김영권 4857 2.3%
 
이덕술 4749 2.2%
 
김영경 4241 2.0%
 
제이앤지 1848 0.9%
 
심상열 1818 0.8%
 
고달진 1703 0.8%
 
안미나 1489 0.7%
 
Other values (2147) 87333 40.6%
 

Length

Max length11
Mean length4.831027365
Min length2
ValueCountFrequency (%) 
Other_Letter 252 96.9%
 
Uppercase_Letter 4 1.5%
 
Decimal_Number 2 0.8%
 
Open_Punctuation 1 0.4%
 
Close_Punctuation 1 0.4%
 
ValueCountFrequency (%) 
Hangul 252 96.9%
 
Common 4 1.5%
 
Latin 4 1.5%
 
ValueCountFrequency (%) 
Hangul 252 96.9%
 
ASCII 8 3.1%
 

부서
Categorical

HIGH CARDINALITY
Distinct count575
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size1.6 MiB
차용갑
 
24354
김선
 
22611
관리부
 
20067
직영팀
 
15348
특판영업
 
10735
Other values (570)
121979
ValueCountFrequency (%) 
차용갑 24354 11.3%
 
김선 22611 10.5%
 
관리부 20067 9.3%
 
직영팀 15348 7.1%
 
특판영업 10735 5.0%
 
강대석 7831 3.6%
 
CJ오쇼핑 7183 3.3%
 
이진희 6187 2.9%
 
이덕술 6074 2.8%
 
이충호(SM라이프) 4636 2.2%
 
Other values (565) 90068 41.9%
 

Length

Max length12
Mean length4.397765628
Min length2
ValueCountFrequency (%) 
Other_Letter 275 92.3%
 
Decimal_Number 10 3.4%
 
Uppercase_Letter 9 3.0%
 
Open_Punctuation 1 0.3%
 
Space_Separator 1 0.3%
 
Close_Punctuation 1 0.3%
 
Other_Punctuation 1 0.3%
 
ValueCountFrequency (%) 
Hangul 275 92.3%
 
Common 14 4.7%
 
Latin 9 3.0%
 
ValueCountFrequency (%) 
Hangul 275 92.3%
 
ASCII 23 7.7%
 

연체횟수
Real number (ℝ)

ZEROS
Distinct count352
Unique (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.40128037044269
Minimum-447
Maximum119
Zeros118228
Zeros (%)55.0%
Memory size1.6 MiB

Quantile statistics

Minimum-447
5-th percentile0
Q10
median0
Q334
95-th percentile92
Maximum119
Range566
Interquartile range (IQR)34

Descriptive statistics

Standard deviation37.12385834
Coefficient of variation (CV)2.133398092
Kurtosis24.98001465
Mean17.40128037
Median Absolute Deviation (MAD)25.41706959
Skewness-2.079096372
Sum3742911
Variance1378.180858
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-447. -385.5 -361.5 -342.5 -339.5 ... 99.5 109.5 116.5 118.5 119. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 118228 55.0%
 
1 4983 2.3%
 
99 3586 1.7%
 
2 2372 1.1%
 
5 1885 0.9%
 
57 1862 0.9%
 
3 1758 0.8%
 
4 1688 0.8%
 
50 1535 0.7%
 
53 1526 0.7%
 
Other values (342) 75671 35.2%
 
ValueCountFrequency (%) 
-447 1 < 0.1%
 
-386 1 < 0.1%
 
-385 2 < 0.1%
 
-384 2 < 0.1%
 
-381 2 < 0.1%
 
ValueCountFrequency (%) 
119 149 0.1%
 
118 83 < 0.1%
 
117 60 < 0.1%
 
116 52 < 0.1%
 
115 42 < 0.1%
 

성별
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.6 MiB
113400
101671
기타
 
23
ValueCountFrequency (%) 
113400 52.7%
 
101671 47.3%
 
기타 23 < 0.1%
 

Length

Max length2
Mean length1.00010693
Min length1
ValueCountFrequency (%) 
Other_Letter 4 100.0%
 
ValueCountFrequency (%) 
Hangul 4 100.0%
 
ValueCountFrequency (%) 
Hangul 4 100.0%
 

나이
Real number (ℝ≥0)

Distinct count91
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean55.55914623373967
Minimum21
Maximum120
Zeros0
Zeros (%)0.0%
Memory size1.6 MiB

Quantile statistics

Minimum21
5-th percentile31
Q146
median56
Q365
95-th percentile79
Maximum120
Range99
Interquartile range (IQR)19

Descriptive statistics

Standard deviation14.22322881
Coefficient of variation (CV)0.2560015726
Kurtosis-0.4298260064
Mean55.55914623
Median Absolute Deviation (MAD)11.55502349
Skewness0.007568506106
Sum11950439
Variance202.3002378
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 21. 22.5 23.5 24.5 25.5 ... 108.5 109.5 112. 119.5 120. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
60 6518 3.0%
 
59 6261 2.9%
 
58 6111 2.8%
 
52 6033 2.8%
 
55 5876 2.7%
 
56 5852 2.7%
 
61 5840 2.7%
 
53 5569 2.6%
 
62 5525 2.6%
 
54 5511 2.6%
 
Other values (81) 155998 72.5%
 
ValueCountFrequency (%) 
21 112 0.1%
 
22 182 0.1%
 
23 313 0.1%
 
24 483 0.2%
 
25 671 0.3%
 
ValueCountFrequency (%) 
120 24 < 0.1%
 
119 3 < 0.1%
 
118 1 < 0.1%
 
117 1 < 0.1%
 
114 2 < 0.1%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Missing values

Sample

First rows

df_index회원번호회원이름주소상태가입일자최종불입일자총납입회차최종불입회차상품금액총불입액해약금액담당자부서연체횟수성별나이
000022A00001이옥성590318경기만기_해약2008-09-082016-12-20100100224000001944000더피플라이프관리부061
110072A00001안성열581125경기행사2007-09-282012-10-04100100224000000더피플라이프관리부062
220072A00002배준택831121부산가입2007-10-232013-05-2010068216320000더피플라이프관리부3237
330072A00003배민규821023울산행사2007-10-232014-12-31100100224000000더피플라이프관리부038
440072A00006최금순340728경기행사2007-10-312016-01-05100100224000000더피플라이프관리부086
550072A00007주병오520206서울해약2007-11-192013-08-0510070216800001212000더피플라이프관리부3068
660072A00021정성제760210서울만기2008-03-312016-06-20100100224000000더피플라이프관리부044
770072A00022신영주541016충청만기2008-04-142018-03-20100100224000000더피플라이프관리부066
880072A00026윤일선521001서울해약2008-09-232016-08-2510096223040001866000더피플라이프관리부468
990072A00027김건용530815서울만기2008-09-232016-12-30100100224000000더피플라이프관리부067

Last rows

df_index회원번호회원이름주소상태가입일자최종불입일자총납입회차최종불입회차상품금액총불입액해약금액담당자부서연체횟수성별나이
215084234600U022A21089백쌍순320814부산해약2008-12-192013-09-231005821392000912000더피플라이프관리부4288
215085234601U022A21090손희락520228부산해약2008-12-192015-10-2010083219920001613000더피플라이프관리부1768
215086234602U022A21305길준분660312부산해약2008-12-222013-10-141005421296000828000더피플라이프관리부4654
215087234605U022A21379김관수370127경남해약2008-12-232010-07-261002024800000더피플라이프관리부8083
215088234606U022A22154김순옥561026부산해약2009-01-072009-03-2010032720000더피플라이프관리부9764
215089234607U022A22155조길찬761012부산해약2009-01-072009-04-2710032720000더피플라이프관리부9744
215090234609U244A00803배상호820807부산해약2008-12-162012-06-296043217200001240000더피플라이프관리부1738
215091234610U244A00804배규태830402부산만기2008-12-162013-11-256060224000000더피플라이프관리부037
215092234611U244A00805김군자490809부산해약2008-12-162008-12-186012400000더피플라이프관리부5971
215093234612U244A00806정일선540801부산해약2008-12-162009-11-25601224800000더피플라이프관리부4866